package com.sino.second.dao.hibernate;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.sino.second.bean.SysXmpsdj;
import com.sino.second.bean.SysXmpsmc;
import com.sino.second.bean.SysXmpszb;
import com.sino.second.bean.TblXmpfbz;

public class BaseDataDAO extends HibernateDaoSupport {
	/**
	 * 项目等级列表
	 * @return
	 */
	public List<SysXmpsdj> findXmpsdjList(){
		String str_SQL="from SysXmpsdj ";
		return this.getHibernateTemplate().find(str_SQL);
		
	}
	/**
	 * 根据ID取等级
	 * @param id 等级ID
	 * @return
	 */
	public SysXmpsdj findXmpsdj(String id){
		return (SysXmpsdj)this.getHibernateTemplate().get(SysXmpsdj.class, id);
	}
	/**
	 * 项目评审名称
	 * @return
	 */
	public List<SysXmpsmc> findXmpsmcList(){
		String str_SQL="from SysXmpsmc ";
		return this.getHibernateTemplate().find(str_SQL);
		
		
	}
	/**
	 * 根据ID取名称
	 * @param id 名称ID
	 * @return
	 */
	public SysXmpsmc findXmpsmc(String id){
		return (SysXmpsmc)this.getHibernateTemplate().get(SysXmpsmc.class, id);
	}
	/**
	 * 项目评审指标
	 */
	public List<SysXmpszb> findXmpszbList(){
		String str_SQL="from SysXmpszb  order by id";
		return this.getHibernateTemplate().find(str_SQL);
		
		
	}
	/**
	 * 根据ID取指标
	 * @param id 指标ID
	 * @return
	 */
	public SysXmpszb findXmpszb(String id){
		return (SysXmpszb)this.getHibernateTemplate().get(SysXmpszb.class, id);
	}
	/**
	 * 项目评分标准
	 */
	public List<TblXmpfbz> findXmpfbzList(){
		String str_SQL="from TblXmpfbz order by id";
		return this.getHibernateTemplate().find(str_SQL);
		
		
	}
	/**
	 * 根据ID取评分
	 * @param id 评分ID
	 * @return
	 */
	public TblXmpfbz findXmpfbz(String id){
		return (TblXmpfbz)this.getHibernateTemplate().get(TblXmpfbz.class, id);
	}

}
